1 using System;
2 using System.Collections.Generic;
3 using System.ComponentModel;
4 using System.Drawing;
5 using System.Data;
6 using System.Linq;
7 using System.Text;
8 using System.Threading.Tasks;
9 using System.Windows.Forms;
10 using System.Data.SqlClient;
11
12 namespace SoftQuanLyNhaHang.Models
13 {
14 class KhoMod
15 {
16 protected int PageSize { get; set; }
17 protected int PageIndex { get; set; }
18
19 protected int IdKho { get; set; }
20 protected string MaSanPham { get; set; }
21 protected string TenSanPham { get; set; }
22 protected int NhomSanPhamId { get; set; }
23 protected int DonViTinhId { get; set; }
24 protected int DanhMucId { get; set; }
25 protected int NhaCungCapId { get; set; }
26 protected int NhapHangId { get; set; }
27 protected string AnhDaiDien { get; set; }
28 protected int HanMucDatHang { get; set; }
29 protected string HanSuDung { get; set; }
30 protected string NgaySanXuat { get; set; }
31 protected DateTime NgayHetHan { get; set; }
32 protected string MoTa { get; set; }
33 protected double GiaNhap { get; set; }
34 protected double SoLuong { get; set; }
35 protected double Thue { get; set; }
36 protected double ChietKhauPhanTram { get; set; }
37 protected double TiLeLoiNhuan { get; set; }
38 protected double GiaBanLe { get; set; }
39 protected double GiaBanBuon { get; set; }
40 protected double GiaKhuyenMai { get; set; }
41 protected DateTime NgayBatDauGiamGia { get; set; }
42 protected DateTime NgayKetThuc { get; set; }
43 protected string TrangThai { get; set; }
44 protected DateTime NgayTao { get; set; }
45 protected string ChietKhauTheo { get; set; }
46
47 protected double TienThue { get; set; }
48 protected double TienChietKhau { get; set; }
49
50 protected string MaVietTat { get; set; }
51 protected double ThueBanHang { get; set; }
52 protected double ChietKhauPTBanHang { get; set; }
53
54 protected float SoLuongDaBan { get; set; }
55 //protected string MaVietTat_DieuKien { get; set; }
56 //protected string MaSanPham_DieuKien { get; set; }
57
58 protected int KhachHangId { get; set; }
59
60 public KhoMod()
61 {
62
63 }
64
65 public KhoMod(int _IdKho)
66 {
67 IdKho = _IdKho;
68 }
69
70 public KhoMod(string _MaSanPham)
71 {
72 MaSanPham = _MaSanPham;
73 }
74
75 public KhoMod(string _MaSanPham, int _NhapHangId)
76 {
77 MaSanPham = _MaSanPham;
78 NhapHangId = _NhapHangId;
79 }
80
81 public KhoMod(int _IdKho, string _MaSanPham, int _KhachHangId)
82 {
83 IdKho = _IdKho;
84 MaSanPham = _MaSanPham;
85 KhachHangId = _KhachHangId;
86 }
87
88
89 public KhoMod(int _IdKho, double _Thue)
90 {
91 IdKho = _IdKho;
92 Thue = _Thue;
93 }
94
95 public KhoMod(int _IdKho, float _SoLuong, float _SoLuongDaBan)
96 {
97 IdKho = _IdKho;
98 SoLuong = _SoLuong;
99 SoLuongDaBan = _SoLuongDaBan;
100 }
101
102 public KhoMod(int _IdKho, int _NhaCungCapId, int _NhapHangId)
103 {
104 IdKho = _IdKho;
105 NhaCungCapId = _NhaCungCapId;
106 NhapHangId = _NhapHangId;
107 }
108
109 public KhoMod(int _IdKho, int _NhaCungCapId, string _TrangThai, int _NhapHangId)
110 {
111 IdKho = _IdKho;
112 NhaCungCapId = _NhaCungCapId;
113 TrangThai = _TrangThai;
114 NhapHangId = _NhapHangId;
115 }
116
117
118 public KhoMod(int _IdKho, int _NhapHangId, int _pageSize, int _pageIndex)
119 {
120 IdKho = _IdKho;
121 NhapHangId = _NhapHangId;
122 PageSize = _pageSize;
123 PageIndex = _pageIndex;
124 }
125 public KhoMod(string _maVietTat, int _pageSize, int _pageIndex)
126 {
127 MaVietTat = _maVietTat;
128 PageSize = _pageSize;
129 PageIndex = _pageIndex;
130 }
131
132 public KhoMod(int _IdKho, string _MaSanPham, string _MaVietTat, string _TenSanPham, double _SoLuong)
133 {
134 IdKho = _IdKho;
135 MaSanPham = _MaSanPham;
136 MaVietTat = _MaVietTat;
137 TenSanPham = _TenSanPham;
138 SoLuong = _SoLuong;
139 }
140
141 public KhoMod(string _MaSanPham, int _NhapHangId, string _MaVietTat)
142 {
143 MaSanPham = _MaSanPham;
144 NhapHangId = _NhapHangId;
145 MaVietTat = _MaVietTat;
146 }
147
148 public KhoMod(int _IdKho, int _NhapHangId, string _TrangThai)
149 {
150 IdKho = _IdKho;
151 NhapHangId = _NhapHangId;
152 TrangThai = _TrangThai;
153 }
154
155
156 public KhoMod(int _IdKho, string _MaVietTat, double _TiLeLoiNhuan, double _GiaBanLe, double _GiaBanBuon, double _GiaKhuyenMai, double _ThueBanHang, double _ChietKhauPTBanHang)
157 {
158 IdKho = _IdKho;
159 MaVietTat = _MaVietTat;
160 TiLeLoiNhuan = _TiLeLoiNhuan;
161 GiaBanLe = _GiaBanLe;
162 GiaBanBuon = _GiaBanBuon;
163 GiaKhuyenMai = _GiaKhuyenMai;
164 ThueBanHang = _ThueBanHang;
165 ChietKhauPTBanHang = _ChietKhauPTBanHang;
166 }
167
168 public KhoMod(int _IdKho, string _MaSanPham, string _MaVietTat, double _TiLeLoiNhuan, double _GiaBanLe, double _GiaBanBuon, double _GiaKhuyenMai, double _ThueBanHang, double _ChietKhauPTBanHang)
169 {
170 IdKho = _IdKho;
171 MaSanPham = _MaSanPham;
172 MaVietTat = _MaVietTat;
173 TiLeLoiNhuan = _TiLeLoiNhuan;
174 GiaBanLe = _GiaBanLe;
175 GiaBanBuon = _GiaBanBuon;
176 GiaKhuyenMai = _GiaKhuyenMai;
177 ThueBanHang = _ThueBanHang;
178 ChietKhauPTBanHang = _ChietKhauPTBanHang;
179 }
180
181 public KhoMod(int _IdKho, string _MaSanPham, string _MaVietTat, string _TenSanPham, int _DonViTinhId, double _GiaNhap, double _SoLuong, double _Thue, double _ChietKhauPhanTram, string _ChietKhauTheo, double _TienChietKhau)
182 {
183 IdKho = _IdKho;
184 MaSanPham = _MaSanPham;
185 MaVietTat = _MaVietTat;
186 TenSanPham = _TenSanPham;
187 DonViTinhId = _DonViTinhId;
188 GiaNhap = _GiaNhap;
189 SoLuong = _SoLuong;
190 Thue = _Thue;
191 ChietKhauPhanTram = _ChietKhauPhanTram;
192 ChietKhauTheo = _ChietKhauTheo;
193 TienChietKhau = _TienChietKhau;
194 }
195
196 public KhoMod(int _IdKho, string _MaSanPham, string _TenSanPham, int _NhomSanPhamId, int _DonViTinhId, int _DanhMucId, int _NhaCungCapId, int _NhapHangId, string _AnhDaiDien, int _HanMucDatHang, string _HanSuDung, string _NgaySanXuat, DateTime _NgayHetHan, string _MoTa, double _GiaNhap, double _SoLuong, double _Thue, double _ChietKhauPhanTram, double _TiLeLoiNhuan, double _GiaBanLe, double _GiaBanBuon, double _GiaKhuyenMai, DateTime _NgayBatDauGiamGia, DateTime _NgayKetThuc, string _TrangThai, DateTime _NgayTao, string _ChietKhauTheo, double _TienThue, double _TienChietKhau, string _MaVietTat, float _ThueBanHang, float _ChietKhauPTBanHang, float _SoLuongDaBan)
197 {
198 IdKho = _IdKho;
199 MaSanPham = _MaSanPham;
200 TenSanPham = _TenSanPham;
201 NhomSanPhamId = _NhomSanPhamId;
202 DonViTinhId = _DonViTinhId;
203 DanhMucId = _DanhMucId;
204 NhaCungCapId = _NhaCungCapId;
205 NhapHangId = _NhapHangId;
206 AnhDaiDien = _AnhDaiDien;
207 HanMucDatHang = _HanMucDatHang;
208 HanSuDung = _HanSuDung;
209 NgaySanXuat = _NgaySanXuat;
210 NgayHetHan = _NgayHetHan;
211 MoTa = _MoTa;
212 GiaNhap = _GiaNhap;
213 SoLuong = _SoLuong;
214 Thue = _Thue;
215 ChietKhauPhanTram = _ChietKhauPhanTram;
216 TiLeLoiNhuan = _TiLeLoiNhuan;
217 GiaBanLe = _GiaBanLe;
218 GiaBanBuon = _GiaBanBuon;
219 GiaKhuyenMai = _GiaKhuyenMai;
220 NgayBatDauGiamGia = _NgayBatDauGiamGia;
221 NgayKetThuc = _NgayKetThuc;
222 TrangThai = _TrangThai;
223 NgayTao = _NgayTao;
224 ChietKhauTheo = _ChietKhauTheo;
225 TienThue = _TienThue;
226 TienChietKhau = _TienChietKhau;
227 MaVietTat = _MaVietTat;
228 ThueBanHang= _ThueBanHang;
229 ChietKhauPTBanHang = _ChietKhauPTBanHang;
230 SoLuongDaBan = _SoLuongDaBan;
231 }
232
233 public KhoMod(int _IdKho, string _MaSanPham, string _TenSanPham, int _NhomSanPhamId, int _DonViTinhId, int _DanhMucId, int _NhaCungCapId, int _NhapHangId, string _AnhDaiDien, int _HanMucDatHang, string _HanSuDung, string _NgaySanXuat, DateTime _NgayHetHan, string _MoTa, double _GiaNhap, double _SoLuong, double _Thue, double _ChietKhauPhanTram, double _TiLeLoiNhuan, double _GiaBanLe, double _GiaBanBuon, double _GiaKhuyenMai, DateTime _NgayBatDauGiamGia, DateTime _NgayKetThuc, string _TrangThai, DateTime _NgayTao, string _ChietKhauTheo, double _TienThue, double _TienChietKhau, int _PageSize, int _PageIndex)
234 {
235 IdKho = _IdKho;
236 MaSanPham = _MaSanPham;
237 TenSanPham = _TenSanPham;
238 NhomSanPhamId = _NhomSanPhamId;
239 DonViTinhId = _DonViTinhId;
240 DanhMucId = _DanhMucId;
241 NhaCungCapId = _NhaCungCapId;
242 NhapHangId = _NhapHangId;
243 AnhDaiDien = _AnhDaiDien;
244 HanMucDatHang = _HanMucDatHang;
245 HanSuDung = _HanSuDung;
246 NgaySanXuat = _NgaySanXuat;
247 NgayHetHan = _NgayHetHan;
248 MoTa = _MoTa;
249 GiaNhap = _GiaNhap;
250 SoLuong = _SoLuong;
251 Thue = _Thue;
252 ChietKhauPhanTram = _ChietKhauPhanTram;
253 TiLeLoiNhuan = _TiLeLoiNhuan;
254 GiaBanLe = _GiaBanLe;
255 GiaBanBuon = _GiaBanBuon;
256 GiaKhuyenMai = _GiaKhuyenMai;
257 NgayBatDauGiamGia = _NgayBatDauGiamGia;
258 NgayKetThuc = _NgayKetThuc;
259 TrangThai = _TrangThai;
260 NgayTao = _NgayTao;
261 ChietKhauTheo = _ChietKhauTheo;
262 TienThue = _TienThue;
263 TienChietKhau = _TienChietKhau;
264 PageSize = _PageSize;
265 PageIndex = _PageIndex;
266 }
267
268 //Them moi kho
269 public int InsertKho()
270 {
271 int i = 0;
272 string[] paras = new string[33] { "@IdKho", "@MaSanPham", "@TenSanPham", "@NhomSanPhamId", "@DonViTinhId", "@DanhMucId", "@NhaCungCapId", "@NhapHangId", "@AnhDaiDien", "@HanMucDatHang", "@HanSuDung", "@NgaySanXuat", "@NgayHetHan", "@MoTa", "@GiaNhap", "@SoLuong", "@Thue", "@ChietKhauPhanTram", "@TiLeLoiNhuan", "@GiaBanLe", "@GiaBanBuon", "@GiaKhuyenMai", "@NgayBatDauGiamGia", "@NgayKetThuc", "@TrangThai", "@NgayTao", "@ChietKhauTheo", "@TienThue", "@TienChietKhau", "@MaVietTat", "@ThueBanHang", "@ChietKhauPTBanHang", "@SoLuongDaBan" };
273 object[] values = new object[33] { IdKho, MaSanPham, TenSanPham, NhomSanPhamId, DonViTinhId, DanhMucId, NhaCungCapId, NhapHangId, AnhDaiDien, HanMucDatHang, HanSuDung, NgaySanXuat, NgayHetHan, MoTa, GiaNhap, SoLuong, Thue, ChietKhauPhanTram, TiLeLoiNhuan, GiaBanLe, GiaBanBuon, GiaKhuyenMai, NgayBatDauGiamGia, NgayKetThuc, TrangThai, NgayTao, ChietKhauTheo, TienThue, TienChietKhau, MaVietTat, ThueBanHang,ChietKhauPTBanHang,SoLuongDaBan};
274 i = Int32.Parse(Models.connection.ExcuteScalar("tbl_Kho_Insert", CommandType.StoredProcedure, paras, values));
275 return i;
276 }
277
278 //insert sp khác số lượng
279 public int InsertKho_Select_ByIdKho()
280 {
281 int i = 0;
282 string[] paras = new string[5] { "@IdKho", "@MaSanPham", "@MaVietTat", "@TenSanPham", "@SoLuong" };
283 object[] values = new object[5] { IdKho, MaSanPham, MaVietTat, TenSanPham, SoLuong };
284 i = Int32.Parse(Models.connection.ExcuteScalar("tbl_Kho_Insert_ByIdKho", CommandType.StoredProcedure, paras, values));
285 return i;
286 }
287
288 //insert sp by nhap nhanh
289 public int InsertKho_Select_NhapNhanh_ByNhapHangId()
290 {
291 int i = 0;
292 string[] paras = new string[3] { "@MaSanPham", "@NhapHangId", "@MaVietTat" };
293 object[] values = new object[3] { MaSanPham, NhapHangId, MaVietTat };
294 i = Int32.Parse(Models.connection.ExcuteScalar("tbl_Kho_Insert_Select_NhapNhanh_ByNhapHangId", CommandType.StoredProcedure, paras, values));
295 return i;
296 }
297
298 //update kho
299 public int UpdateKho()
300 {
301 int i = 0;
302 string[] paras = new string[33] { "@IdKho", "@MaSanPham", "@TenSanPham", "@NhomSanPhamId", "@DonViTinhId", "@DanhMucId", "@NhaCungCapId", "@NhapHangId", "@AnhDaiDien", "@HanMucDatHang", "@HanSuDung", "@NgaySanXuat", "@NgayHetHan", "@MoTa", "@GiaNhap", "@SoLuong", "@Thue", "@ChietKhauPhanTram", "@TiLeLoiNhuan", "@GiaBanLe", "@GiaBanBuon", "@GiaKhuyenMai", "@NgayBatDauGiamGia", "@NgayKetThuc", "@TrangThai", "@NgayTao", "@ChietKhauTheo", "@TienThue", "@TienChietKhau", "@MaVietTat", "@SoLuongDaBan", "@ThueBanHang", "@ChietKhauPTBanHang"};
303 object[] values = new object[33] { IdKho, MaSanPham, TenSanPham, NhomSanPhamId, DonViTinhId, DanhMucId, NhaCungCapId, NhapHangId, AnhDaiDien, HanMucDatHang, HanSuDung, NgaySanXuat, NgayHetHan, MoTa, GiaNhap, SoLuong, Thue, ChietKhauPhanTram, TiLeLoiNhuan, GiaBanLe, GiaBanBuon, GiaKhuyenMai, NgayBatDauGiamGia, NgayKetThuc, TrangThai, NgayTao, ChietKhauTheo, TienThue, TienChietKhau, MaVietTat, ThueBanHang,ChietKhauPTBanHang,SoLuongDaBan };
304 i = Models.connection.Excute_Sql("tbl_Kho_Update", CommandType.StoredProcedure, paras, values);
305 return i;
306 }
307
308 //
309 public int UpdateKho_Thue()
310 {
311 int i = 0;
312 string[] paras = new string[2] { "@IdKho", "@Thue" };
313 object[] values = new object[2] { IdKho, Thue };
314 i = Models.connection.Excute_Sql("tbl_Kho_Update_Thue", CommandType.StoredProcedure, paras, values);
315 return i;
316 }
317
318 //update nha cung cap by idnhaphang
319 public int UpdateKho_NhaCungCapId()
320 {
321 int i = 0;
322 string[] paras = new string[3] { "@IdKho", "@NhaCungCapId", "@NhapHangId" };
323 object[] values = new object[3] { IdKho, NhaCungCapId, NhapHangId };
324 i = Models.connection.Excute_Sql("tbl_Kho_Update_NhaCungCap", CommandType.StoredProcedure, paras, values);
325 return i;
326 }
327
328 //
329 public int UpdateKho_NhaCungCapId_TrangThai_ByNhapHangId()
330 {
331 int i = 0;
332 string[] paras = new string[4] { "@IdKho", "@NhaCungCapId","@TrangThai", "@NhapHangId" };
333 object[] values = new object[4] { IdKho, NhaCungCapId,TrangThai, NhapHangId };
334 i = Models.connection.Excute_Sql("tbl_Kho_Update_NhaCungCap_TrangThai_ByNhapHangId", CommandType.StoredProcedure, paras, values);
335 return i;
336 }
337
338 //update thiet lap gia
339 public int UpdateKho_ThietLapGia()
340 {
341 int i = 0;
342 string[] paras = new string[8] { "@IdKho", "@MaVietTat", "@TiLeLoiNhuan", "@GiaBanLe", "@GiaBanBuon", "@GiaKhuyenMai", "@ThueBanHang", "@ChietKhauPTBanHang" };
343 object[] values = new object[8] { IdKho, MaVietTat, TiLeLoiNhuan, GiaBanLe, GiaBanBuon, GiaKhuyenMai, ThueBanHang, ChietKhauPTBanHang};
344 i = Models.connection.Excute_Sql("tbl_Kho_Update_ThietLapGia", CommandType.StoredProcedure, paras, values);
345 return i;
346 }
347
348 //update thiet lap gia theo ma san pham hoac ma viet tat
349 public int UpdateKho_ThietLapGiaBy_MaSanPham_MaVietTat()
350 {
351 int i = 0;
352 string[] paras = new string[9] { "@IdKho", "@MaSanPham", "@MaVietTat", "@TiLeLoiNhuan", "@GiaBanLe", "@GiaBanBuon", "@GiaKhuyenMai", "@ThueBanHang", "@ChietKhauPTBanHang" };
353 object[] values = new object[9] { IdKho, MaSanPham, MaVietTat, TiLeLoiNhuan, GiaBanLe, GiaBanBuon, GiaKhuyenMai, ThueBanHang, ChietKhauPTBanHang };
354 i = Models.connection.Excute_Sql("tbl_Kho_Update_ThietLapGia_ByMaSanPham_MaVietTat", CommandType.StoredProcedure, paras, values);
355 return i;
356 }
357
358 //update ma viet ta va ma san pham
359 public int UpdateKho_ByMaSanPham_MaVietTat()
360 {
361 int i = 0;
362 string[] paras = new string[5] {"@IdKho", "@MaSanPham", "@MaVietTat", "@TenSanPham", "@SoLuong" };
363 object[] values = new object[5] { IdKho, MaSanPham, MaVietTat, TenSanPham, SoLuong};
364 i = Models.connection.Excute_Sql("tbl_Kho_Update_ByMaSanPham_MaVietTat", CommandType.StoredProcedure, paras, values);
365 return i;
366 }
367
368 //update trangthai by nhaphang
369 public int UpdateKho_TrangThai_ByNhapHang()
370 {
371 int i = 0;
372 string[] paras = new string[3] { "@IdKho", "@NhapHangId","@TrangThai" };
373 object[] values = new object[3] { IdKho, NhapHangId, TrangThai };
374 i = Models.connection.Excute_Sql("tbl_Kho_Update_TrangThai_ByNhapHangId", CommandType.StoredProcedure, paras, values);
375 return i;
376 }
377
378 //update soluong da ban
379 public int UpdateKho_SoLuongDaBan_ByIdKho()
380 {
381 int i = 0;
382 string[] paras = new string[3] { "@IdKho", "@SoLuong", "@SoLuongDaBan" };
383 object[] values = new object[3] { IdKho, SoLuong, SoLuongDaBan };
384 i = Models.connection.Excute_Sql("tbl_Kho_Update_SoLuongDaBan_ByIdKho", CommandType.StoredProcedure, paras, values);
385 return i;
386 }
387
388
389 //update trong form nhap hang
390 public int UpdateKho_FormNhapHang()
391 {
392 int i = 0;
393 string[] paras = new string[11] { "@IdKho", "@MaSanPham", "@MaVietTat", "@TenSanPham", "@DonViTinhId", "@GiaNhap", "@SoLuong", "@Thue", "@ChietKhauPhanTram", "@ChietKhauTheo", "@TienChietKhau" };
394 object[] values = new object[11] { IdKho, MaSanPham, MaVietTat, TenSanPham, DonViTinhId, GiaNhap, SoLuong, Thue, ChietKhauPhanTram, ChietKhauTheo, TienChietKhau };
395 i = Models.connection.Excute_Sql("tbl_Kho_Update_FormNhapHang", CommandType.StoredProcedure, paras, values);
396 return i;
397 }
398
399 //Delete kho
400 public int DeleteKho()
401 {
402 int i = 0;
403 string[] paras = new string[1] { "@IdKho" };
404 object[] values = new object[1] { IdKho };
405 i = Models.connection.Excute_Sql("tbl_Kho_Delete", CommandType.StoredProcedure, paras, values);
406 return i;
407 }
408
409 //Select
410 public DataSet FillDataSet_getKho_ByMaSanPham()
411 {
412 DataSet ds = new DataSet();
413 string[] paras = new string[1] { "@MaSanPham" };
414 object[] values = new object[1] { MaSanPham };
415 ds = Models.connection.FillDataSet("tbl_Kho_Gets_ByMaSanPham", CommandType.StoredProcedure, paras, values);
416 return ds;
417 }
418
419 //ma san pham hoac ma viet tat
420 public DataSet FillDataSet_getKho_ByMaSanPham_OrMaVietTat()
421 {
422 DataSet ds = new DataSet();
423 string[] paras = new string[1] { "@MaSanPham" };
424 object[] values = new object[1] { MaSanPham };
425 ds = Models.connection.FillDataSet("tbl_Kho_Gets_ByMaSanPham_OrMaVietTat", CommandType.StoredProcedure, paras, values);
426 return ds;
427 }
428
429 //lay theo ma san pham
430
431 public DataSet FillDataSet_getKho_ByMaSanPhamByNotInIdKho()
432 {
433 DataSet ds = new DataSet();
434 string[] paras = new string[3] { "@IdKho", "@MaSanPham", "@KhachHangId" };
435 object[] values = new object[3] { IdKho, MaSanPham, KhachHangId };
436 ds = Models.connection.FillDataSet("tbl_Kho_Gets_ByMaSanPham_NotInIdKho", CommandType.StoredProcedure, paras, values);
437 return ds;
438 }
439 //Lấy theo mã sản phẩm, mã đơn hàng
440 public DataSet FillDataSet_getKho_ByMaSanPham_ByNhapHangId()
441 {
442 DataSet ds = new DataSet();
443 string[] paras = new string[2] { "@MaSanPham", "@NhapHangId" };
444 object[] values = new object[2] { MaSanPham, NhapHangId };
445 ds = Models.connection.FillDataSet("tbl_Kho_Gets_ByMaSanPham_ByNhapHangId", CommandType.StoredProcedure, paras, values);
446 return ds;
447 }
448
449 //Lấy theo ma viet tat, mã đơn hàng
450 public DataSet FillDataSet_getKho_ByMaSanPham_ByNhapHangId_MaVietTat()
451 {
452 DataSet ds = new DataSet();
453 string[] paras = new string[3] { "@MaSanPham", "@NhapHangId", "@MaVietTat" };
454 object[] values = new object[3] { MaSanPham, NhapHangId, MaVietTat };
455 ds = Models.connection.FillDataSet("tbl_Kho_Gets_ByMaSanPham_ByNhapHangId_MaVietTat", CommandType.StoredProcedure, paras, values);
456 return ds;
457 }
458
459 //Hien thi danh sach trong kho by NhapHangId
460 public DataSet FillDataSet_getKho_ByNhapHangId()
461 {
462 DataSet ds = new DataSet();
463 string[] paras = new string[4] { "@IdKho", "@NhapHangId" , "@PageSize","@PageIndex"};
464 object[] values = new object[4] { IdKho, NhapHangId, PageSize, PageIndex };
465 ds = Models.connection.FillDataSet("tbl_Kho_Gets_ByNhapHangId", CommandType.StoredProcedure, paras, values);
466 return ds;
467 }
468
469
470 //Hien thi danh sach trong kho by NhapHangId
471 public DataSet FillDataSet_getKho_AllSearch()
472 {
473 DataSet ds = new DataSet();
474 string[] paras = new string[31] { "@IdKho", "@MaSanPham", "@TenSanPham", "@NhomSanPhamId", "@DonViTinhId", "@DanhMucId", "@NhaCungCapId", "@NhapHangId", "@AnhDaiDien", "@HanMucDatHang", "@HanSuDung", "@NgaySanXuat", "@NgayHetHan", "@MoTa", "@GiaNhap", "@SoLuong", "@Thue", "@ChietKhauPhanTram", "@TiLeLoiNhuan", "@GiaBanLe", "@GiaBanBuon", "@GiaKhuyenMai", "@NgayBatDauGiamGia", "@NgayKetThuc", "@TrangThai", "@NgayTao", "@ChietKhauTheo", "@TienThue", "@TienChietKhau","@PageSize", "@PageIndex" };
475 object[] values = new object[31] { IdKho, MaSanPham, TenSanPham, NhomSanPhamId, DonViTinhId, DanhMucId, NhaCungCapId, NhapHangId, AnhDaiDien, HanMucDatHang, HanSuDung, NgaySanXuat, NgayHetHan, MoTa, GiaNhap, SoLuong, Thue, ChietKhauPhanTram, TiLeLoiNhuan, GiaBanLe, GiaBanBuon, GiaKhuyenMai, NgayBatDauGiamGia, NgayKetThuc, TrangThai, NgayTao, ChietKhauTheo, TienThue, TienChietKhau, PageSize, PageIndex };
476 ds = Models.connection.FillDataSet("tbl_Kho_Gets_AllSearch", CommandType.StoredProcedure, paras, values);
477 return ds;
478 }
479
480 //chi hien thi một sản phẩm có cùng mã vạch hoặc mã viết tắt trong một bảng
481 public DataSet FillDataSet_getKho_AllSearch_ByHaving()
482 {
483 DataSet ds = new DataSet();
484 string[] paras = new string[31] { "@IdKho", "@MaSanPham", "@TenSanPham", "@NhomSanPhamId", "@DonViTinhId", "@DanhMucId", "@NhaCungCapId", "@NhapHangId", "@AnhDaiDien", "@HanMucDatHang", "@HanSuDung", "@NgaySanXuat", "@NgayHetHan", "@MoTa", "@GiaNhap", "@SoLuong", "@Thue", "@ChietKhauPhanTram", "@TiLeLoiNhuan", "@GiaBanLe", "@GiaBanBuon", "@GiaKhuyenMai", "@NgayBatDauGiamGia", "@NgayKetThuc", "@TrangThai", "@NgayTao", "@ChietKhauTheo", "@TienThue", "@TienChietKhau", "@PageSize", "@PageIndex" };
485 object[] values = new object[31] { IdKho, MaSanPham, TenSanPham, NhomSanPhamId, DonViTinhId, DanhMucId, NhaCungCapId, NhapHangId, AnhDaiDien, HanMucDatHang, HanSuDung, NgaySanXuat, NgayHetHan, MoTa, GiaNhap, SoLuong, Thue, ChietKhauPhanTram, TiLeLoiNhuan, GiaBanLe, GiaBanBuon, GiaKhuyenMai, NgayBatDauGiamGia, NgayKetThuc, TrangThai, NgayTao, ChietKhauTheo, TienThue, TienChietKhau, PageSize, PageIndex };
486 ds = Models.connection.FillDataSet("tbl_Kho_Gets_AllSearch_ByHaving", CommandType.StoredProcedure, paras, values);
487 return ds;
488 }
489
490
491 //danh sach ton kho
492 public DataSet FillDataSet_getKho_AllSearch_ByHaving_Hai()
493 {
494 DataSet ds = new DataSet();
495 string[] paras = new string[31] { "@IdKho", "@MaSanPham", "@TenSanPham", "@NhomSanPhamId", "@DonViTinhId", "@DanhMucId", "@NhaCungCapId", "@NhapHangId", "@AnhDaiDien", "@HanMucDatHang", "@HanSuDung", "@NgaySanXuat", "@NgayHetHan", "@MoTa", "@GiaNhap", "@SoLuong", "@Thue", "@ChietKhauPhanTram", "@TiLeLoiNhuan", "@GiaBanLe", "@GiaBanBuon", "@GiaKhuyenMai", "@NgayBatDauGiamGia", "@NgayKetThuc", "@TrangThai", "@NgayTao", "@ChietKhauTheo", "@TienThue", "@TienChietKhau", "@PageSize", "@PageIndex" };
496 object[] values = new object[31] { IdKho, MaSanPham, TenSanPham, NhomSanPhamId, DonViTinhId, DanhMucId, NhaCungCapId, NhapHangId, AnhDaiDien, HanMucDatHang, HanSuDung, NgaySanXuat, NgayHetHan, MoTa, GiaNhap, SoLuong, Thue, ChietKhauPhanTram, TiLeLoiNhuan, GiaBanLe, GiaBanBuon, GiaKhuyenMai, NgayBatDauGiamGia, NgayKetThuc, TrangThai, NgayTao, ChietKhauTheo, TienThue, TienChietKhau, PageSize, PageIndex };
497 ds = Models.connection.FillDataSet("tbl_Kho_Gets_AllSearch_ByHaving_hai", CommandType.StoredProcedure, paras, values);
498 return ds;
499 }
500
501 //Hien thi danh sach trong kho by IdKho
502 public DataSet FillDataSet_getKho_ByIdKho()
503 {
504 DataSet ds = new DataSet();
505 string[] paras = new string[1] { "@IdKho"};
506 object[] values = new object[1] { IdKho };
507 ds = Models.connection.FillDataSet("tbl_Kho_Gets_ByIdKho", CommandType.StoredProcedure, paras, values);
508 return ds;
509 }
510
511
512 //san pham tiep theo
513
514 public DataSet FillDataSet_getKho_ByIdKho_Next_Back()
515 {
516 DataSet ds = new DataSet();
517 string[] paras = new string[1] { "@IdKho"};
518 object[] values = new object[1] { IdKho};
519 ds = Models.connection.FillDataSet("tbl_Kho_ByIdKho_Next_Back", CommandType.StoredProcedure, paras, values);
520 return ds;
521 }
522
523
524 //lay san pham theo ma san pham hoac ma viet tat
525 public DataSet FillDataSet_getKho_ByMaSanPham_MaVietTat()
526 {
527 DataSet ds = new DataSet();
528 string[] paras = new string[3] { "@MaSanPham", "@NhapHangId", "@MaVietTat" };
529 object[] values = new object[3] { MaSanPham, NhapHangId, MaVietTat };
530 ds = Models.connection.FillDataSet("tbl_Kho_Gets_ByMaSanPham_MaVietTat", CommandType.StoredProcedure, paras, values);
531 return ds;
532 }
533
534 public DataSet FillDataSet_getKho_ByMaSanPham_MaVietTat_All()
535 {
536 DataSet ds = new DataSet();
537 string[] paras = new string[3] { "@MaSanPham", "@NhapHangId", "@MaVietTat" };
538 object[] values = new object[3] { MaSanPham, NhapHangId, MaVietTat };
539 ds = Models.connection.FillDataSet("tbl_Kho_Gets_ByMaSanPham_MaVietTat_All", CommandType.StoredProcedure, paras, values);
540 return ds;
541 }
542
543 //lay cac san pham ton kho theo masp
544 public DataSet FillDataSet_GetSCac_SP_TonKho_ByMaSanPham()
545 {
546 DataSet ds = new DataSet();
547 string[] paras = new string[3] { "@MaSanPham", "@NhapHangId", "@MaVietTat" };
548 object[] values = new object[3] { MaSanPham, NhapHangId, MaVietTat };
549 ds = Models.connection.FillDataSet("tbl_Kho_GetSCac_SP_TonKho_ByMaSanPham", CommandType.StoredProcedure, paras, values);
550 return ds;
551 }
552
553 //Mã sản phẩn đã tồn tại ở cột masanpham thì không được insert vào maviettat
554 public DataSet FillDataSet_getKho_ByMaSanPham_MaVietTat_KiemTraTonTai()
555 {
556 DataSet ds = new DataSet();
557 string[] paras = new string[3] { "@MaSanPham", "@NhapHangId", "@MaVietTat" };
558 object[] values = new object[3] { MaSanPham, NhapHangId, MaVietTat };
559 ds = Models.connection.FillDataSet("tbl_Kho_Gets_MaSanPham_MaVietTat_KiemTraTonTai", CommandType.StoredProcedure, paras, values);
560 return ds;
561 }
562
563 //lay theo ma viet tat
564 public DataSet FillDataSet_getKho_ByMaVietTat()
565 {
566 DataSet ds = new DataSet();
567 string[] paras = new string[3] { "@MaSanPham", "@NhapHangId", "@MaVietTat" };
568 object[] values = new object[3] { MaSanPham, NhapHangId, MaVietTat };
569 ds = Models.connection.FillDataSet("tbl_Kho_Gets_ByMaVietTat", CommandType.StoredProcedure, paras, values);
570 return ds;
571 }
572 //tong mat hang trong kho
573 public DataSet FillDataSet_getKho_COUNT_ByMaVietTat()
574 {
575 DataSet ds = new DataSet();
576 string[] paras = new string[3] { "@MaSanPham", "@NhapHangId", "@MaVietTat" };
577 object[] values = new object[3] { MaSanPham, NhapHangId, MaVietTat };
578 ds = Models.connection.FillDataSet("tbl_Kho_COUNT_ByMaVietTat", CommandType.StoredProcedure, paras, values);
579 return ds;
580 }
581
582 // tih ton kho
583 public DataSet FillDataSet_getKho_Gets_ByMaVietTatTongTonKho()
584 {
585 DataSet ds = new DataSet();
586 string[] paras = new string[3] { "@MaSanPham", "@NhapHangId", "@MaVietTat" };
587 object[] values = new object[3] { MaSanPham, NhapHangId, MaVietTat };
588 ds = Models.connection.FillDataSet("tbl_Kho_Gets_ByMaVietTatTongTonKho", CommandType.StoredProcedure, paras, values);
589 return ds;
590 }
591
592 //lay danh sach san pham
593 public DataSet FillDataSet_getKho_GetSCac_SP_TonKho_ByMaSanPham_Search()
594 {
595 DataSet ds = new DataSet();
596 string[] paras = new string[3] {"@MaVietTat","@PageSize", "@PageIndex" };
597 object[] values = new object[3] { MaVietTat,PageSize, PageIndex };
598 ds = Models.connection.FillDataSet("tbl_Kho_GetSCac_SP_TonKho_ByMaSanPham_Search", CommandType.StoredProcedure, paras, values);
599 return ds;
600 }
601 }
602 }
